package com.ctshk.rpc.order.airexpress.mapper;

import com.ctshk.rpc.order.airexpress.base.CustomBaseMapper;
import com.ctshk.rpc.order.airexpress.entity.AirportExpressOrderReceipt;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 机场快线订单收据 Mapper 接口
 * </p>
 *
 * @author 叶冠峰
 * @since 2021-03-22
 */
public interface AirportExpressOrderReceiptMapper extends CustomBaseMapper<AirportExpressOrderReceipt> {
    @Select("select id, order_id, license_no, support_no, receipt_no, transaction_time, branch, guest, phone, attention, remark, gmt_create, create_id, gmt_modified, modified_id, is_deleted from t_airport_express_order_receipt aeor where aeor.order_id=#{orderId} order by aeor.gmt_create desc limit 1")
    AirportExpressOrderReceipt selectFirst(@Param("orderId") Long orderId);
}
